package com.ruoyi.user.mapper;

import com.ruoyi.common.core.domain.R;
import com.ruoyi.user.domain.UcenterMember;
import com.ruoyi.user.domain.bo.MyCourseBo;
import com.ruoyi.user.domain.bo.OneClassify;
import com.ruoyi.user.domain.vo.UcenterMemberVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * 用户Mapper接口
 *
 * @author 孟磊
 * @date 2022-08-18
 */
public interface UcenterMemberMapper extends BaseMapperPlus<UcenterMemberMapper, UcenterMember, UcenterMemberVo> {
    List<OneClassify> queryclassify();

    List<OneClassify> queryTeacher();

    List<OneClassify> average();

    List<OneClassify> week();

    List<MyCourseBo> mycourse(int id);


//    @Select("select edu_subject.title,sum(t_order.total_fee) from edu_subject" +
//        "inner join edu_course on edu_subject.id = edu_course.subject_parent_id" +
//        "inner join t_order on edu_course.id = t_order.course_id" +
//        "GROUP BY  edu_course.subject_parent_id")

}
